Tabela PhLPackUnitHist

Definicja tabeli PhLPackUnitHist

Name

PhLPackUnitHist

Code

PhLPackUnitHist

Comment

Tabela przechowujaca dane historyczne z PhLPackUnit


Lista kolumn tabeli PhLPackUnitHist

Name

Code

rev

rev

RevTypeID

RevTypeID

LPackVatRateID

LPackVatRateID

VatRateId

VatRateId

PackId

PackId

FromDt

FromDt

ToDt

ToDt

insertDate

insertDate

insertingPerson

insertingPerson

lastModifiedDT

lastModifiedDT

lastModifiedPerson

lastModifiedPerson

LPackUnitID

LPackUnitID

Quantity

Quantity

UnitID

UnitID


Kolumna rev tabeli PhLPackUnitHist

Definicja kolumny rev tabeli PhLPackUnitHist

Name

rev

Code

rev

Data Type

NUMBER(10)

Mandatory

No

Comment

FK do tabeli
REVINFO-REV


Kolumna RevTypeID tabeli PhLPackUnitHist

Definicja kolumny RevTypeID tabeli PhLPackUnitHist

Name

RevTypeID

Code

RevTypeID

Data Type

NUMBER(3)

Mandatory

No

Comment

Type zmiany


Kolumna LPackVatRateID tabeli PhLPackUnitHist

Definicja kolumny LPackVatRateID tabeli PhLPackUnitHist

Name

LPackVatRateID

Code

LPackVatRateID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna VatRateId tabeli PhLPackUnitHist

Definicja kolumny VatRateId tabeli PhLPackUnitHist

Name

VatRateId

Code

VatRateId

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PackId tabeli PhLPackUnitHist

Definicja kolumny PackId tabeli PhLPackUnitHist

Name

PackId

Code

PackId

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna FromDt tabeli PhLPackUnitHist

Definicja kolumny FromDt tabeli PhLPackUnitHist

Name

FromDt

Code

FromDt

Data Type

DATE

Mandatory

No

Comment

 


Kolumna ToDt tabeli PhLPackUnitHist

Definicja kolumny ToDt tabeli PhLPackUnitHist

Name

ToDt

Code

ToDt

Data Type

DATE

Mandatory

No

Comment

 


Kolumna insertDate tabeli PhLPackUnitHist

Definicja kolumny insertDate tabeli PhLPackUnitHist

Name

insertDate

Code

insertDate

Data Type

DATE

Mandatory

No

Comment

 


Kolumna insertingPerson tabeli PhLPackUnitHist

Definicja kolumny insertingPerson tabeli PhLPackUnitHist

Name

insertingPerson

Code

insertingPerson

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna lastModifiedDT tabeli PhLPackUnitHist

Definicja kolumny lastModifiedDT tabeli PhLPackUnitHist

Name

lastModifiedDT

Code

lastModifiedDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna lastModifiedPerson tabeli PhLPackUnitHist

Definicja kolumny lastModifiedPerson tabeli PhLPackUnitHist

Name

lastModifiedPerson

Code

lastModifiedPerson

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna LPackUnitID tabeli PhLPackUnitHist

Definicja kolumny LPackUnitID tabeli PhLPackUnitHist

Name

LPackUnitID

Code

LPackUnitID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Quantity tabeli PhLPackUnitHist

Definicja kolumny Quantity tabeli PhLPackUnitHist

Name

Quantity

Code

Quantity

Data Type

NUMBER(19,8)

Mandatory

No

Comment

 


Kolumna UnitID tabeli PhLPackUnitHist

Definicja kolumny UnitID tabeli PhLPackUnitHist

Name

UnitID

Code

UnitID

Data Type

NUMBER(10)

Mandatory

No

Comment